2015-05-06 - XXXX - Service Request - Time stamp causing the change in billing date and time in ETI Extract File - (Daniel Brennan by 2015-05-07) #invoices

2015-05-06 - XXXX - Service Request - Time stamp causing the change in billing date and time in ETI Extract file

Problem Summary


The invoice creation date and time is displayed wrongly in the mexico ETI file.

Admin Info



Purpose
The invoice creation date and time is displayed wrongly in the mexico ETI file.
Requested by
Daniel Brennan
Issue Date
05-06-2015
Resolved by
Deepak Yasam and Damodhier Sanagana
Resolved Date
05-07-2015
Document Status
Completed

Detailed Problem Description

(Include Screen Shots if required )

Date on some of their electronic invoicing files that are being sent to EDICOM is 4/30/2015. However, the billing date on the SAP document is 5/1/2015, and the created on date is 5/2/2015.


Solution Analysis and Recommendations

(Include Screen Shots if required)

In the Mexico ETI Extract program we have made the logic to change the time from EST to PST . For this , the invoice billing date and the creation time are considered and converted to PST.

For the invoice 0092685425 ,billing date is 05/01/2015 and created time 01:00:15 . So while converting from EST to PST the time would be lesser by 3 hours changing the date to 04/30/2015 and time to 22:00:15 as below.

ETI Extract.jpg

Resolution




Release Information


Provide link here to Release Notes if Technical Objects were changed